| |
161 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 February 2022 02:45 «»
By: piripicchio
Re: Getting ORA-24374 , when using function in with query
…| INDEX UNIQUE SCAN | I_USER1 | 1 | | 0 (0)| 00:00:01 |
|* 11 | INDEX RANGE SCAN | I_OBJ2 | 1 | 106 | 2 (0)| 00:00:01 |
|* 12 | TABLE ACCESS BY INDEX ROWID…
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 17 January 2002 04:56 «»
By: S. Hill
need to create a "read only" user
…need to create a user(lets call this user USER1) that can only select data in user2's tables (just allow USER1 to read the data only). User2 owns the tables. There are over 400 tables so I don't want to grant select on each one. Is there someway to grant …
|
| 3 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Fri, 10 March 2023 15:04 «»
By: wtolentino
How To Get APEX users who are currently active
…
---------- ----------------------------------------
0015941536 APEXME
9454048894 USER1
8043592063 USER2
How do I link this to the v$session view so I can get the info about who is currently have active session?
Please advise. Thank you…
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 12 February 2002 12:08 «»
By: Sal wheelar
User Authentication by SQL Queries ???
…I authenticate database user without connecting to database by passing userid and password.
Suppose I have connected to database as User1.
Can I issue queries with userid and passwords as parameters of other users to check whether they are valid users…
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 17 January 2002 11:28 «»
By: Mike
Re: need to create a "read only" user
… such a command but you can create a script like that:
connect to sqlplus as user2 and execute folowing statements:
set heading off
spool c:grant.sql
select 'grant select on '||table_name||' to user1;' from user_tables;
spool off
@c:grant.sql
HTH
…
|
| 6 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 18 October 2021 09:31 «»
By: Reversi72
Re: Long query with WITH not responding
… 0 0 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=21 us cost=0 size=0 card=1)(object id 46)
********************************************************************************
SQL ID: gz03nfakdg5kp Plan Hash: 0
CREATE GLOBAL …
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 14 October 2021 07:57 «»
By: Reversi72
Re: Long query with WITH not responding
… 0 0 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=29 us cost=0 size=0 card=1)(object id 46)
********************************************************************************
SQL ID: 96g93hntrzjtr Plan Hash: 841937906
select…
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 14 October 2021 03:50 «»
By: Reversi72
Re: Long query with WITH not responding
…pid=1 pos=1 obj=46 op='INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=29 us cost=0 size=0 card=1)'
CLOSE #4575511936:c=4,e=13,dep=2,type=1,tim=56034783415504
EXEC #4575458432:c=2499,e=131811,p=0,cr=182,cu=5,mis=0,r=0,dep=1,og=4,plh=0,tim=56034783415674…
|
| 9 |
Forum: Spatial «»
Posted on: Fri, 20 August 2021 16:18 «»
By: gchiluveru
ORA-13034: Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object (split from "ORA-0939: too many arguments for function")
…to the database 135.13.19.112_ads_user1_sc.
ORA-20001: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-06512: at "ADS_USER1_SC.TESTGANFUNCTION1", line 33
ORA-06512: at line 5
EXCEPTION WHILE SAVING TO ADS
ORA-29875: …
|
| 10 |
Forum: Server Administration «»
Posted on: Tue, 27 July 2021 14:54 «»
By: wtolentino
Re: Unified Auditing Trail to find grants of privileges on an object
…again
SQL> grant select on table1 to user1;
Grant succeeded.
SQL> grant update on table1 to user1;
Grant succeeded.
select action_name, sql_text from UNIFIED_AUDIT_TRAIL order by event_timestamp desc;
ACTION_NAME SQL_TEXT…
|
| 11 |
Forum: Server Administration «»
Posted on: Tue, 27 July 2021 13:19 «»
By: wtolentino
Re: Unified Auditing Trail to find grants of privileges on an object
…ceeded.
SQL> grant select on table1 to user1;
Grant succeeded.
SQL> grant insert on table1 to user1;
Grant succeeded.
SQL> grant delete on table1 to user1;
Grant succeeded.
SQL> grant update on table1 to user1;
Grant …
|
| 12 |
Forum: Server Administration «»
Posted on: Tue, 27 July 2021 07:12 «»
By: wtolentino
Re: Unified Auditing Trail to find grants of privileges on an object
…
for example:
grant select on table1 to user1;
grant select on table1 to role1;
how do use the CREATE AUDIT POLICY? i tried this but looks like it is not correct.
CREATE AUDIT POLICY table_privilege_grant_policy
privileges grant select any …
|
| 13 |
Forum: Server Administration «»
Posted on: Tue, 27 July 2021 05:32 «»
By: wtolentino
Unified Auditing Trail to find grants of privileges on an object
…for example:
grant select on table1 to user1;
grant select on table1 to role1;
this didn't appears recording into the UNIFIED_AUDIT_TRAIL view. we don't see any rows that are related to the granting of an objects.
checking the v$option returns …
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 08 June 2021 08:36 «»
By: Solomon Yakobson
Re: Compare rows
… from t
),
r(
id_user1,
id_user2,
lvl,
cnt,
best
) as (
select d1.id_user id_user1,
d2.id_user id_user2,
d1.lvl,
d1.cnt,
case…
|
| 15 |
Forum: Server Utilities «»
Posted on: Mon, 29 March 2021 23:08 «»
By: narenjoshi@yahoo.com
Taking backup of your own Schema without DBA provs
…as well ?"
I did try
exp USER1/PASS1@SVC_NAME file=/tmp/dumpfile.dmp log=/tmp/db.log owner='USER1'
It started the export, but gave error EXP-00111 Table XYX resides in an encrypted Tablespace XYZXYXZ and will not be exported…
|
| 16 |
Forum: Forms «»
Posted on: Wed, 10 June 2020 09:48 «»
By: sarah1992
User Access on different Modules(forms)
…
and If i have 5 Users
I want those 5 users have different access such as User1 only access department and employee and user2 only access HR and account.
how to grant them different access?
i am using oracle forms 12C R4 and database 12c…
|
| 17 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 April 2020 11:03 «»
By: buggleboy007
Extracting specific portion of a string using REGEX
…(or two records) of the type:
a) C:\Users\user1\Pictures\1.JPG
b) C:\Users\user1\Pictures\file_example_TIFF_1MB.tiff
I am using the following query to extract the name of the file and I am only able to pull the 1st record out (1.JPG). How can I …
|
| 18 |
Forum: Client Tools «»
Posted on: Sat, 28 March 2020 11:33 «»
By: Andrey_R
Re: Client fails to connect to new DB server with "TNS-03505: Failed to resolve name"
…
Here:
C:\Users\user1>sqlplus system/Newproj2020@MYDB
SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 28 18:28:35 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect …
|
| 19 |
Forum: Client Tools «»
Posted on: Sat, 28 March 2020 10:41 «»
By: Andrey_R
Client fails to connect to new DB server with "TNS-03505: Failed to resolve name"
…of successful connection ) :
C:\Users\user1>telnet 10.1.140.70 1521
However, when I try to tnsping or connect with sqlplus , I get the following error:
C:\Users\user1>
C:\Users\user1>tnsping MYDB
TNS Ping Utility for 32-bit Windows…
|
| 20 |
Forum: Programming Interfaces «»
Posted on: Thu, 21 March 2019 15:42 «»
By: a100
Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges
…the following permissions:
'CREATE USER user1 IDENTIFIED BY "pass" DEFAULT TABLESPACE users QUOTA unlimited ON users'
'GRANT CREATE SESSION TO user1'
'GRANT CREATE TABLE TO user1'
'GRANT CREATE VIEW TO user1'
'GRANT CREATE SEQUENCE TO …
|
| 21 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 26 October 2018 14:50 «»
By: BlackSwan
Re: How to allow multi-users in Procedure
GRANT EXECUTE ON account_api TO USER1;
GRANT EXECUTE ON account_api TO USER2;
GRANT EXECUTE ON account_api TO USER3;
|
| 22 |
Forum: Client Tools «»
Posted on: Wed, 17 October 2018 15:09 «»
By: Michel Cadot
Re: Password Expired
… you will see it works:
SQL> create user user1 identified by "lzs3!RSESY" account unlock
2 password expire;
User created.
SQL> GRANT CREATE SESSION TO user1;
Grant succeeded.
SQL> conn user1/"lzs3!RSESY"
…
|
| 23 |
Forum: Client Tools «»
Posted on: Wed, 17 October 2018 14:55 «»
By: wtolentino
Password Expired
…is what I did.
I created the account user1 originally as:
create user user1 identified by "lzs3!RSESY"
default tablespace users
temporary tablespace temp
account unlock
password expire;
grant connect to user1;
GRANT CREATE …
|
| 24 |
Forum: Client Tools «»
Posted on: Wed, 10 October 2018 08:07 «»
By: wtolentino
Re: SQL*Plus output problem
…comma
prompt example user1, user2, user3
accept iUserName prompt "";
accept iDynamicYN prompt "execute immediate [Y/N]: ";
declare
vRoleName varchar2(40) := '&&iRoleName';
vSchemaName…
|
| 25 |
Forum: Forms «»
Posted on: Wed, 03 October 2018 07:51 «»
By: RaShi.Raj
ORA-01031: insufficient privileges in Forms
…ges. When forms user, same as oracle user ( user1 ) tries to enter some data in forms and save, forms throw error 'ORA-01031 - Insufficient Privileges' while executing INSERT INTO statement.
If I login to oracle via back end as the same user (user1) …
|
| 26 |
Forum: Client Tools «»
Posted on: Fri, 28 September 2018 00:49 «»
By: Michel Cadot
Re: SQL*Plus output problem
…
4
5 vDynamicSQL := 'create user user1 identified by "lax4g!VCdm"' || chr(10) ||
6 'default tablespace user '|| chr(10) ||
7 'temporary tablespace temp ' || chr(10) ||
8 '…
|
| 27 |
Forum: Client Tools «»
Posted on: Thu, 27 September 2018 15:04 «»
By: wtolentino
Re: SQL*Plus output problem
for example in this format
create user user1 identified by "lax4g!VCdm"
default tablespace user
temporary tablespace temp
account unlock password expire;
|
| 28 |
Forum: Client Tools «»
Posted on: Thu, 27 September 2018 14:12 «»
By: Michel Cadot
Re: SQL*Plus output problem
…L> exec dbms_output.put_line('create user user1 identified by "lax4g!VCdm" default tablespace user temporary tablespace temp account unlock password expire;');
create user user1 identified by "lax4g!VCdm" default tablespace user…
|
| 29 |
Forum: Client Tools «»
Posted on: Thu, 27 September 2018 13:53 «»
By: wtolentino
SQL*Plus output problem (merged 3)
…00);
begin
vDynamicSQL := 'create user user1 identified by "lax4g!VCdm"' || chr(10) ||
'default tablespace user '|| chr(10) ||
'temporary tablespace temp ' || chr(10) ||
'account unlock…
|
| 30 |
Forum: Forms «»
Posted on: Wed, 08 August 2018 08:06 «»
By: Michel Cadot
Re: Cursor For Loop Auto Increment
…
SQL> select max(decode(user_nb, 1, xyz)) user1,
2 max(decode(user_nb, 2, xyz)) user2,
3 max(decode(user_nb, 3, xyz)) user3
4 from ( select decode(nb, 1, 'Result for '||s.users, rpad(' ',length(s.users)+11))||
5…
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 20 June 2018 13:08 «»
By: Solomon Yakobson
Re: Fetching Unix Folder Name and Timestamp in SQL/PLSQL
…SELECT on the view to desired user, e.g. USER1:
grant select on trace_file_dir_list_vw to user1
/
Step 6. Login as USER1 and issue:
SQL> select *
2 from directory_master.trace_file_dir_list_vw
3 where rownum <= 3
4…
|
| 32 |
Forum: Server Administration «»
Posted on: Fri, 01 June 2018 07:13 «»
By: EdStevens
Re: oracle user does not see some data
Others have hinted, but just to spell it out ...
When user1 issues 'select .... from den ..' he is selecting from user1.den.
When user2 issues 'select .... from den ..' he is selecting from user2.den.
Different tables, different results.
|
| 33 |
Forum: Security «»
Posted on: Thu, 10 May 2018 00:23 «»
By: MeghaB
Re: How to setup Password rotation
…T=1
app1, app2, app3 use User1/password1
T=2
User2/password2 changed to new value
T=3
app1, app2,app3, are transitioned to User2/password2
T=4
User1 password changed to password2
Next change User2/password2 are transitioned to User1/password3…
|
| 34 |
Forum: General «»
Posted on: Mon, 08 January 2018 07:59 «»
By: BlackSwan
Re: SQL Report running manually not through cron
You can create & SQLPLUS will utilize your own private copy of tnsnmes.ora when named as below
/data/myuser/user1/.tnsnames.ora
Notice that there is a dot (".") preceding and as part of actual filename.
|
| 35 |
Forum: General «»
Posted on: Fri, 05 January 2018 21:54 «»
By: dba4oracle
Re: SQL Report running manually not through cron
…
below is env.capture
HOME=/data/myuser/user1
HOST=IAPL1
LANG=en_US.UTF-8
LOGNAME=user1
MAILTO=myuser@mycompany.com
ORACLE_HOME=/opt/u01/app/oracle/product/11.2.0.4/client
PASSWORD=abc123
PATH=/opt/u01/app/oracle/product/11.2.0.4/client/…
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 18 December 2017 18:26 «»
By: SoratoMan
Oracle 12c injection
…sesion priviliges.
So if vulnerable procedure vulnProc was created by user1, how user2, who have only create session , execute on vulnProc and select on table1(which created by user1) priviligies, can insert into table1 or delete any row from it…
|
| 37 |
Forum: Forms «»
Posted on: Wed, 25 October 2017 07:14 «»
By: adil shakeel
set_block_property
…NEW FORM INSTANCE TRIGGER.
, SO THAT IF USER1 OPENS THE FORM THEN IT DISPLAYS MESSAGE "YOU HAVE NO RIGHTS TO VIEW THIS FORM"
pLEASE GUIDE ME.
secondly logic I want to apply is that when any particular group of users opens the same form…
|
| 38 |
Forum: Linux «»
Posted on: Tue, 26 September 2017 07:23 «»
By: snuggiebear
Re: sudo sqlplus -v returns "Error 6 initializing SQL*Plus"
Thanks John. I can get this working with the following in sudoers:
user1 ALL=(oracle) NOPASSWD: ALL
Would you know the discrete sudoers definition to run just the required command ? Appreciate this is diverging from Oracle itself.
|
| 39 |
Forum: Linux «»
Posted on: Tue, 26 September 2017 05:15 «»
By: snuggiebear
sudo sqlplus -v returns "Error 6 initializing SQL*Plus"
…as sudoers.
I have set in sudoers:
user1 ALL=(oracle) NOPASSWD: /u01/app/oracle/product/11.2.0/dbhome_1/bin/sqlplus
I then login with user1 and execute:
export ORACLE_SID=wujjii
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export…
|
| 40 |
Forum: Forms «»
Posted on: Thu, 07 September 2017 02:23 «»
By: chat2raj.s
Forms 6i Installation Error
I am trying to install forms 6i in windows 7 64 bit machine and encountered with the following error message. How can I solve this ?
user1.pin(20): OS_ERROR while spawning ifsvr60 - install Forms60Server port=9000 mode=Socket batch=yes
|
Blog
Search
Help
Members
Register
Login
Home